﻿CREATE TABLE [dbo].[Calificacion] (
    [IdCalificacion] INT           IDENTITY (1, 1) NOT NULL,
    [IdPeriodo]      INT           NOT NULL,
    [IdEstudiante]   INT           NOT NULL,
    [Nota]           DECIMAL (18)  NOT NULL,
    [Descripcion]    VARCHAR (300) NOT NULL,
    PRIMARY KEY CLUSTERED ([IdCalificacion] ASC),
    CONSTRAINT [FK_Calificacion_Periodo] FOREIGN KEY ([IdPeriodo]) REFERENCES [dbo].[Periodo] ([IdPeriodo])
);

